# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月09日
"""
import pandas as pd

path = '../数据文件/课件013-014/筛选.xlsx'
data = pd.read_excel(path, index_col='序号', sheet_name='Sheet1')

# data2 = data.loc[2:4]

# con = data['性别'] == '男'
# query查询
# con = "性别 == '男' and 总分 >= 150"
con = "姓名 in ['李平平', '王刚']"

print(data.query(con))
# print(data[data['性别'] == '男'])
